package com.ruoyi.finance.collection.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.common.annotation.DataSource;
import com.ruoyi.common.enums.DataSourceType;
import com.ruoyi.finance.collection.domain.VBillCollection;
import com.ruoyi.finance.collection.domain.validation.VBillCollectionLeftJoinVProjectTos;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
* @author 80661
* @description 针对表【V_BILL_COLLECTION】的数据库操作Mapper
* @createDate 2023-07-04 14:03:44
* @Entity finance.collection.domain.VBillCollection
*/
public interface VBillCollectionMapper extends BaseMapper<VBillCollection> {
    //对账单ID查询收款费项
    @DataSource(DataSourceType.SLAVE)
    List<VBillCollection> listVBCollectionByStatementId(@Param("statementId")Long statementId);
    
    //生成对账单时，根据传入的费项ID列表和公司代码查询相关业务数据
    List<VBillCollectionLeftJoinVProjectTos> listVBillCollectionLeftJoinVProjectTos(@Param("BILL_COLLECTION_IDS")String billCollectionIdS, @Param("COMPANY_COD")String companyCod);
    
    Long getConIdByStatementId(@Param("STATEMENT_ID")Long statementId);

}




